Budget Distribution Rules

In Retail Sales Budgets, when the top-down approach is used, the budget values can be automatically distributed based on Budget Distribution Rules.

There are 3 types of distribution calculation:

  • Equal - Distributes an amount equally between the number of elements.
  • Proportional - Distributes an amount based on the distribution of the existing values.
  • Curve - Distributes an amount based on manual weight assignment, or a distribution curve such as Lifecycle Curve or Allocation Rule.

These calculation types can be applied on 3 distribution types:

  • Item - Applicable for Division, Item Category, Product Group, Item, or Item Hierarchy.
  • Store - Applicable for Store.
  • Date - Applicable for Date Period in Day, Week, Month, Quarter, or Year.

Equal distribution

The total amount can be distributed equally between each of the element based on the distribution type.

For example with Item distribution type, when a total amount of 40 is entered on the Product Group line (SOFT DRINK) consisting of 4 items, each element (item) will be distributed equally with the amount of 10:

Description Code Total
Soft Drinks SOFT DRINK 40
Cola 30500 10
Cherry Soda 30510 10
Orange Soda 30520 10
Sparkling Water 30530 10

Proportional distribution

Proportional distribution lets you distribute the amount using the existing distribution ratio, based on the new total entered.

For example, assuming the existing distribution is as below:

Description Code Total
Soft Drinks SOFT DRINK 100
Cola 30500 10
Cherry Soda 30510 20
Orange Soda 30520 30
Sparkling Water 30530 40

Changing the total on the SOFT DRINK line from 100 to 200 will distribute the changed amount to its lower level lines proportionally:

Description Code Total
Soft Drinks SOFT DRINK 200
Cola 30500 20
Cherry Soda 30510 40
Orange Soda 30520 60
Sparkling Water 30530 80

Curve distribution

Curve distribution lets you distribute the amount based on predefined curve values.

The distribution types and their corresponding distribution curves are:

  • Item - Manual weight assignment on the elements in Division, Item Category, Product Group, Item, or Item Hierarchy.
  • Store - Manual weight assignment on stores, or based on the weights from Allocation Rule.
  • Date - Manual weight assignment on date periods, or based on the weights from Lifecycle Curve.

For example, given a Date distribution type with 3 periods having the following percentage shares on a curve:

Period Weight % Share
Period 1 2.00 20%
Period 2 3.00 30%
Period 3 5.00 50%

When a total amount is entered with the curve distribution, each Period will get the distributed amount based on the curve's percentage share.

Description Code Total Period 1 Period 2 Period 3
Cola 30500 500 100 150 250

The total amount of 500 will be distributed to 100, 150 and 250 for each period respectively.

Calculation example

In this example, we have a sales budget with budget type Product Group spanning over 3 periods with 2 assigned stores.

The selected distribution rules and their calculation types are defined as below:

  • Item Distribution = ITEMDIST - Equal
  • Store Distribution = STOREDIST - Equal
  • Date Distribution = DATEDIST - Curve

The distribution of the curve used in DATEDIST:

Period Weight % Share
Period 1 2.00 20%
Period 2 3.00 30%
Period 3 5.00 50%

By entering 1,000 in the Total field of the BEVERAGES line, the amount will be distributed down based on the distribution rules selected.

The total of 1,000 is distributed to the Product Groups COFFEE, DISTILLED, SOFT DRINK, and OTHER based on the selected Item Distribution ITEMDIST. With Equal type distribution, each Product Group is distributed with the amount of 250.

Next, the amount on each Product Group is distributed equally to 2 stores based on the Store Distribution STOREDIST. In this case, from the amount of 250, each Store is distributed with the amount of 125.

Lastly, for each Store under each Product Group, the amount is further distributed by the Date Distribution DATEDIST. For example on the line of Product Group SOFT DRINK for Store S0001, based on the total of 125, the Date Distribution uses the defined curve and assigns 25, 37.5 and 62.5 to the 3 periods respectively.

Tasks

The tasks listed below describe the setup steps for Budget Distribution Rules:

To See
Set up an Item Distribution Rule How to: Set Up an Item Distribution Rule
Set up a Store Distribution Rule How to: Set Up a Store Distribution Rule
Set up a Date Distribution Rule How to: Set Up a Date Distribution Rule

See Also

Retail Budgets

Retail Sales Budgets

Lifecycle Curve

Allocation Rule